<?php session_start();

if(isset($_SESSION['authorised']) && $_SESSION['authorised'] == true)
{
	if(isset($_SESSION['type']))
	{
		if($_SESSION['type'] == 'administrator')
		{
			header('Location: admin_index.php');
			exit();
		}
		elseif($_SESSION['type'] == 'student')
		{
			header('Location: student_index.php');
			exit();
		}
		elseif($_SESSION['type'] == 'tutor')
		{
			header('Location: tutor_index.php');
			exit();
		}
		elseif($_SESSION['type'] == 'parent')
		{
			$host = 'localhost';
			$dbuser = 'postgres';
			$dbpass = 'password';
			$dbname = $_SESSION['database'];
			$username = $_SESSION['user'];

			pg_connect("host=$host user=$dbuser password=$dbpass dbname=$dbname") or die(pg_last_error());
			$sql = "SELECT * FROM users WHERE username = '$username';";
			$result = pg_query($sql);
			$firstname = pg_fetch_result($result, 0, 'firstname');
			$middlename = pg_fetch_result($result, 0, 'middlename');
			$lastname = pg_fetch_result($result, 0, 'lastname');
			$birthday = pg_fetch_result($result, 0, 'birthday');
			$gender = pg_fetch_result($result, 0, 'gender');
			?>
			
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Edit Profile</title>
<link href="StyleSheet.css" rel="stylesheet" type="text/css" />
<style>
.nav {
	width: 210px;
	height: auto;
	margin-left: 10px;
	text-align: center;
}

.mainline {
	width: 712px;
	height: auto;
	text-align: center;
}
</style>
</head>

<body bgcolor="#FFFFFF">
	<center>

		<div id="wrapper">
			<div id="header">
				<h1></h1>
			</div>

			<div id="header2">
				<h3></h3>
			</div>

			<div id="nav">
				<?php include 'parent_navigation.php';?>
			</div>

			<div id="mainline">
				<h4>Edit Your Profile</h4>
				<div id="body">
				<h3 align="left">Required Information *</h3>
				<form action="parent_changeprofile.php" method="POST">
					<table cellpadding="2" align="center">
						<tr>
							<th align="left" heigh="30" scope="row">Name:</th>
							<td><?php echo "$lastname, $firstname $middlename";?></td>
						</tr>
						<tr>
							<th align="left" height="30" scope="row">Date of Birth:</th>
							<td><?php echo $birthday;?></td>
						</tr>
						<tr>
							<th align="left" height="30" scope="row">Gender *:</th>
							<td><?php echo $gender;?></td>
						</tr>
						<tr>
							<th align="left" height="30" scope="row">Email *:</th>
							<td><input type="text" size="60" maxlength="256" name="email" value="<?php echo pg_fetch_result($result, 0, 'username');?>" />
							</td>
						</tr>
						<tr>
							<th align="left" height="30" scope="row">Street Address 1 *:</th>
							<td><input type="text" size="60" maxlength="256"name="streetadd1" value="<?php echo pg_fetch_result($result, 0, 'streetadd1');?>" />
							</td>
						</tr>
						<tr>
							<th align="left" height="30" scope="row">Street Address 2 *:</th>
							<td><input type="text" size="60" maxlength="256" name="streetadd2" value="<?php echo pg_fetch_result($result, 0, 'streetadd2');?>" />
							</td>
						</tr>
						<tr>
							<th align="left" height="30" scope="row">City *:</th>
							<td><input type="text" size="60" maxlength="256" name="cityadd" value="<?php echo pg_fetch_result($result, 0, 'cityadd');?>" />
							</td>
						</tr>
						<tr>
							<th align="left" height="30" scope="row">Contact Number *:</th>
							<td><input type="text" size="30" maxlength="256" name="contact_num" value="<?php echo pg_fetch_result($result, 0, 'contactnum');?>" /></td>
						</tr>
						<tr>
							<td />
							<td><input name="submit" type="submit" value="Save Changes" /></td>
						</tr>
					</table>
				</form>
			
			</div>
		</div>

		<p align="justify">
			<br />
		</p>
		

		<br class="clearfloat"> <br />

		<div id="footer">
			<p align="center">
				Tutorial Business Manager: info@tbms.com <br />Credits/Engineers:
				Aquino, Chloebelle; Dela Cruz, Roy Erwin; Maliwanag, Ranyel Bryan;
				Manzano, Audrey Ann; Ng, Sheila Regine<br /> <br />copyright 2011
			</p>
		</div>
		</div>

</body>
</html>
<?php
		}
	}
}
else
{
	header('Location: index.php');
}
?>
